Explore

• Explore functionality lets the user upload the data file and select the required metrics on which optimization needs to be performed.
• User can select Investment and Target variables on which optimization need to be performed. Also, the user has the option to select the CPM option if the analysis and optimization need to be performed in terms of impressions.
• Explore tab also provides trend analysis and insights on investment or impression (as selected by the user) and target variables for the selected date range and dimension.

Introduction to UI

• In the application user can upload the file in CSV format only.
• Post upload, the user can select fields from the data - Date, Dimension, Investment and Target. Users can also select the CPM field if analysis needs to be done in impressions instead of investment.
• The user has the option to select the date in Daily or Weekly format. When using weekly data, the user needs to specify the same using the Weekly checkbox option in the input panel.
• While selecting the dimension, the user has the option to select multiple dimensions using the multi-select checkbox option in the drop-down.
• After clicking Submit button, visualization will be shown on the screen based on the selected inputs.
• User has the ability to switch between the tabs post-explore functionality has been implemented successfully.

Visualization

• The explore tab lets the user visualize investment or impressions (as selected by the user) and target for the selected date range and dimensions:
  • Explore tabs provide trend analysis on investment/impression and target variables.
  • It also provides a comparison between multiple dimensions (selected by the user from the multi-select drop-down option) on investment/impression and target variables.

Note: By default, the entire date range is selected based on the data.

Trend Analysis

Dimension Comparison Chart

Backend Logic

• File Upload: The application accepts the data file in CSV format. If the uploaded file is in any other format, it will give an error message to upload the file in the correct format.
• Date Selector: When the date field is selected, it checks whether the date column is in the proper format or not i.e. YYYY-MM-DD. In case the date field is in incorrect format, an error message will be prompted saying "Enter date in YYYY-MM-DD" format.
• Investment, Target and CPM (if selected): It checks whether the respective fields are in numeric format or not, if not error message will be prompted with an appropriate message.
• Dimension: It checks whether the selected field(s) is in string format or not, if not error message will be displayed with an appropriate message.
• Submit: On clicking the submit button following operations takes place in the backend before charts are displayed on the explore screen:   - Check for each of the dimensions that all the dates are present between the start and end date. If missing, that particular date is added with null/zero values in the selected fields (namely Investment, Target and CPM (if selected)). This step is performed for displaying the trend chart on the explore page.   - The above step gets iterated for all the unique dimensions or a combination of dimensions (if multiple fields for a dimension are selected).   - If multiple dimensions are selected, all the dimension fields get concatenated with an underscore as a delimiter.   - If the CPM checkbox option is selected, the Impression field is then computed for each combination of date and dimension using respective Investment and CPM fields.   - Lastly, data aggregation is performed on the selected fields in the input panel (Investment, Target and Impressions (if the CPM checkbox option is selected)).